select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'RO' order by rank asc limit 0,100 Surnames > R > RO > %22

Surnames > R > RO > %22

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
RA RC RE RH RI RM RO RU RY RZ
RO ROA ROB ROC ROD ROE ROF ROG ROH ROI ROJ ROK ROL ROM RON ROO ROP ROQ ROR ROS ROT ROU ROV ROW ROX ROY ROZ

Full Surname List Starting with %22(Alphabetical)